package com.be.beadmin.design.entity;

import com.be.beadmin.common.entity.BaseEntity;
import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;

/**
 * @Author: Mengyang Zhu
 * @Date: 2023/8/29 14:30
 * @Description: BomReview
 */
@Table(name="T_OM_BomReview")
@Data
@Entity
public class BomReview extends BaseEntity {

    @Column(name = "bomBeforeId",columnDefinition = "VARCHAR(50) COMMENT '审批的原bom行的主键' ")
    private  String bomBeforeId;
    @Column(name = "projectName",columnDefinition = "VARCHAR(50) COMMENT '项目名称' not null")
    private String projectName;
    @Column(name = "productCode",columnDefinition = "VARCHAR(50) not null COMMENT '产品/柜体编号' ")
    private String productCode;
    @Column(name = "bomCode",columnDefinition = "VARCHAR(50) COMMENT 'BOM编号' ")
    private String bomCode;
    @Column(name = "bomSequence",columnDefinition = "VARCHAR(50) COMMENT 'BOM行号' ")
    private String bomSequence;
    @Column(name = "materialCode",columnDefinition = "VARCHAR(50) COMMENT '物料编码' ")
    private String materialCode;
    @Column(name = "materialName",columnDefinition = "VARCHAR(50) COMMENT '物料名称' ")
    private String materialName;
    @Column(name = "materialClassification",columnDefinition = "VARCHAR(50) COMMENT '物料分类' ")
    private String materialClassification;
    @Column(name = "materialType",columnDefinition = "VARCHAR(50) COMMENT '物料种类' ")
    private String materialType;
    @Column(name = "materialSpec",columnDefinition = "VARCHAR(50) COMMENT '规格' ")
    private String materialSpec;
    @Column(name = "materialQty",columnDefinition = "int COMMENT '所需物料数量' ")
    private int materialQty;

    //待审核=0，通过=1，驳回=2 未提交=3
    @Column(name = "changeStatus",columnDefinition = "int COMMENT '变更状态：待审核=0，通过=1，驳回=2'")
    private int changeStatus;

    @Column(name = "memo",columnDefinition = "VARCHAR(50)  COMMENT '审核备注'")
    private String memo;
    @Column(name = "positionNo",columnDefinition = "VARCHAR(50) COMMENT '(安装)位置号' ")
    private String positionNo;
    @Column(name = "unit",columnDefinition = "VARCHAR(50) COMMENT '单位' ")
    private String unit;
    @Column(name = "brand",columnDefinition = "VARCHAR(50) COMMENT '品牌' ")
    private String brand;
    @Column(name = "changeSuccess",columnDefinition = "int COMMENT  '变更是否成功：1- 是/0 -否' ")
    private int changeSuccess;
    @Column(name = "version" , columnDefinition = "int COMMENT '版本' ")
    private int version;

    @Column(name = "versionSecond", columnDefinition = "int COMMENT '小版本'")
    private Integer versionSecond;

    @Column(name = "isMax" , columnDefinition = "int COMMENT '是否为最高版本' ")
    private int isMax;

    @Column(name = "userId" , columnDefinition = "VARCHAR(50) COMMENT '申请人id' ")
    private String userId;

    @Column(name = "isJia" , columnDefinition = "VARCHAR(50) COMMENT '是否甲供料' ")
    private String isJia;

    @Column(name = "userName" , columnDefinition = "VARCHAR(50) COMMENT '申请人' ")
    private String userName;

    @Column(name = "reviewMainId", columnDefinition = "VARCHAR(50) COMMENT '主表id'")
    private String reviewMainId;

    @Column(name = "preMaterialQty",columnDefinition = "int COMMENT '修改前所需物料数量' ")
    private Integer preMaterialQty;
}
